home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
garage.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
759b
|
20 lines
/* RCSVER $Id: garage.sql,v 1.5 1999-04-07 18:05:33-05 randy CURRENT $ */
/* *************************************************************************
* Copyright (C) 1998, Agent Systems, Inc. All Rights Reserved.
*
* Name: garage.sql
* Date: 12/28/1998
* memo: Randy Wood
* Description: Create the garage table. This table contains a list of
* all garages defined to the system.
* Changes:
************************************************************************* */
CREATE TABLE garage
(
glid NUMBER(38), /* Internal sw ID of garage */
garage_id NUMBER(38), /* User-defined garage ID */
descr VARCHAR2(40), /* Description of garage */
CONSTRAINT unq_garage UNIQUE (garage_id),
CONSTRAINT pk_garage PRIMARY KEY (glid)
);